| row_id | order_id | order_date | ship_date | ship_mode | customer_id | customer_name | segment | country | city | state | postal_code | region | product_id | category | sub-category | product_name | sales | quantity | discount | profit |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9425 | CA-2014-145254 | 7/23/2014 | 7/27/2014 | Standard Class | NC-18535 | Nick Crebassa | Corporate | United States | San Francisco | California | 94122 | West | TEC-AC-10002167 | Technology | Accessories | Imation<U+00A0>8gb Micro Traveldrive Usb 2.0<U+00A0>Flash Drive | 45.000 | 3 | 0.0 | 4.9500 |
| 7480 | CA-2014-167199 | 1/6/2014 | 1/10/2014 | Standard Class | ME-17320 | Maria Etezadi | Home Office | United States | Henderson | Kentucky | 42420 | South | OFF-FA-10001883 | Office Supplies | Fasteners | Alliance Super-Size Bands, Assorted Sizes | 31.120 | 4 | 0.0 | 0.3112 |
| 4054 | CA-2014-122931 | 9/29/2014 | 10/3/2014 | Standard Class | SM-20950 | Suzanne McNair | Corporate | United States | Philadelphia | Pennsylvania | 19134 | East | OFF-LA-10002945 | Office Supplies | Labels | Permanent Self-Adhesive File Folder Labels for Typewriters, 1 1/8 x 3 1/2, White | 55.440 | 11 | 0.2 | 18.0180 |
| 7805 | CA-2015-102260 | 9/22/2015 | 9/26/2015 | Standard Class | SJ-20125 | Sanjit Jacobs | Home Office | United States | Franklin | Tennessee | 37064 | South | OFF-ST-10002289 | Office Supplies | Storage | Safco Wire Cube Shelving System, For Use as 4 or 5 14” Cubes, Black | 25.424 | 1 | 0.2 | -4.7670 |
| 6752 | CA-2016-154767 | 6/28/2016 | 6/30/2016 | Second Class | BP-11155 | Becky Pak | Consumer | United States | Paterson | New Jersey | 7501 | East | OFF-AP-10000595 | Office Supplies | Appliances | Disposable Triple-Filter Dust Bags | 8.740 | 2 | 0.0 | 2.2724 |
| 4585 | US-2017-163790 | 11/2/2017 | 11/4/2017 | Second Class | NL-18310 | Nancy Lomonaco | Home Office | United States | Danville | California | 94526 | West | OFF-EN-10001335 | Office Supplies | Envelopes | White Business Envelopes with Contemporary Seam, Recycled White Business Envelopes | 76.580 | 7 | 0.0 | 38.2900 |
| 7999 | US-2014-148194 | 5/4/2014 | 5/7/2014 | First Class | BS-11365 | Bill Shonely | Corporate | United States | Seattle | Washington | 98105 | West | FUR-FU-10001852 | Furniture | Furnishings | Eldon Regeneration Recycled Desk Accessories, Smoke | 12.180 | 7 | 0.0 | 3.8976 |
| 2688 | US-2016-128195 | 8/4/2016 | 8/5/2016 | First Class | RA-19285 | Ralph Arnett | Consumer | United States | Peoria | Illinois | 61604 | Central | OFF-BI-10002003 | Office Supplies | Binders | Ibico Presentation Index for Binding Systems | 3.980 | 5 | 0.8 | -6.5670 |
| 5609 | CA-2015-168634 | 12/6/2015 | 12/11/2015 | Standard Class | AF-10870 | Art Ferguson | Consumer | United States | San Francisco | California | 94109 | West | OFF-AP-10001626 | Office Supplies | Appliances | Commercial WindTunnel Clean Air Upright Vacuum, Replacement Belts, Filtration Bags | 7.780 | 2 | 0.0 | 2.0228 |
| 8816 | CA-2015-144274 | 11/23/2015 | 11/25/2015 | Second Class | PW-19240 | Pierre Wener | Consumer | United States | Wilmington | Delaware | 19805 | East | OFF-PA-10001583 | Office Supplies | Paper | 1/4 Fold Party Design Invitations & White Envelopes, 24 8-1/2” X 11” Cards, 25 Env./Pack | 44.100 | 6 | 0.0 | 20.7270 |
| 4853 | CA-2014-107818 | 9/8/2014 | 9/14/2014 | Standard Class | MC-17275 | Marc Crier | Consumer | United States | Pasco | Washington | 99301 | West | OFF-ST-10000736 | Office Supplies | Storage | Carina Double Wide Media Storage Towers in Natural & Black | 485.880 | 6 | 0.0 | 19.4352 |
| 235 | US-2017-100930 | 4/7/2017 | 4/12/2017 | Standard Class | CS-12400 | Christopher Schild | Home Office | United States | Tampa | Florida | 33614 | South | FUR-FU-10004017 | Furniture | Furnishings | Tenex Contemporary Contur Chairmats for Low and Medium Pile Carpet, Computer, 39” x 49” | 258.072 | 3 | 0.2 | 0.0000 |
| 4547 | CA-2015-126557 | 7/12/2015 | 7/17/2015 | Second Class | RL-19615 | Rob Lucas | Consumer | United States | Chicago | Illinois | 60610 | Central | OFF-BI-10003314 | Office Supplies | Binders | Tuff Stuff Recycled Round Ring Binders | 1.928 | 2 | 0.8 | -2.9884 |
| 4376 | CA-2014-166954 | 4/25/2014 | 4/30/2014 | Standard Class | BT-11305 | Beth Thompson | Home Office | United States | San Gabriel | California | 91776 | West | FUR-FU-10003708 | Furniture | Furnishings | Tenex Traditional Chairmats for Medium Pile Carpet, Standard Lip, 36” x 48” | 303.250 | 5 | 0.0 | 63.6825 |
| 5116 | CA-2017-125640 | 7/25/2017 | 7/29/2017 | Standard Class | DD-13570 | Dorothy Dickinson | Consumer | United States | Philadelphia | Pennsylvania | 19134 | East | OFF-LA-10004178 | Office Supplies | Labels | Avery 491 | 3.304 | 1 | 0.2 | 1.0738 |
| 3373 | CA-2017-123778 | 9/23/2017 | 9/30/2017 | Standard Class | BS-11755 | Bruce Stewart | Consumer | United States | San Francisco | California | 94122 | West | OFF-AP-10001242 | Office Supplies | Appliances | APC 7 Outlet Network SurgeArrest Surge Protector | 160.960 | 2 | 0.0 | 48.2880 |
| 1699 | CA-2015-148376 | 12/27/2015 | 12/31/2015 | Standard Class | AG-10900 | Arthur Gainer | Consumer | United States | Los Angeles | California | 90008 | West | OFF-LA-10002381 | Office Supplies | Labels | Avery 497 | 21.560 | 7 | 0.0 | 10.3488 |
| 3079 | CA-2014-104780 | 5/21/2014 | 5/25/2014 | Standard Class | BT-11530 | Bradley Talbott | Home Office | United States | San Diego | California | 92037 | West | OFF-AR-10003514 | Office Supplies | Art | 4009 Highlighters by Sanford | 31.840 | 8 | 0.0 | 10.5072 |
| 9223 | CA-2017-103212 | 10/13/2017 | 10/14/2017 | First Class | MH-18025 | Michelle Huthwaite | Consumer | United States | Lafayette | Louisiana | 70506 | South | OFF-PA-10004355 | Office Supplies | Paper | Xerox 231 | 25.920 | 4 | 0.0 | 12.4416 |
| 9676 | CA-2016-137393 | 5/6/2016 | 5/10/2016 | Standard Class | GM-14500 | Gene McClure | Consumer | United States | Bakersfield | California | 93309 | West | FUR-FU-10001617 | Furniture | Furnishings | Executive Impressions 8-1/2” Career Panel/Partition Cubicle Clock | 41.600 | 4 | 0.0 | 14.1440 |
| 1395 | US-2017-117247 | 10/9/2017 | 10/14/2017 | Standard Class | CK-12760 | Cyma Kinney | Corporate | United States | Aurora | Illinois | 60505 | Central | FUR-TA-10002958 | Furniture | Tables | Bevis Oval Conference Table, Walnut | 652.450 | 5 | 0.5 | -430.6170 |
| 9852 | CA-2016-158155 | 5/2/2016 | 5/6/2016 | Standard Class | EH-13765 | Edward Hooks | Corporate | United States | New York City | New York | 10009 | East | OFF-BI-10001670 | Office Supplies | Binders | Vinyl Sectional Post Binders | 90.480 | 3 | 0.2 | 33.9300 |
| 4869 | CA-2017-122490 | 11/13/2017 | 11/18/2017 | Standard Class | TT-21070 | Ted Trevino | Consumer | United States | Seattle | Washington | 98103 | West | OFF-LA-10001613 | Office Supplies | Labels | Avery File Folder Labels | 8.640 | 3 | 0.0 | 4.2336 |
| 8698 | CA-2017-119284 | 6/15/2017 | 6/20/2017 | Standard Class | TS-21205 | Thomas Seio | Corporate | United States | Nashville | Tennessee | 37211 | South | FUR-FU-10004351 | Furniture | Furnishings | Staple-based wall hangings | 31.168 | 4 | 0.2 | 9.3504 |
| 8036 | CA-2015-119690 | 6/25/2015 | 6/28/2015 | First Class | MV-17485 | Mark Van Huff | Consumer | United States | Houston | Texas | 77041 | Central | OFF-LA-10001613 | Office Supplies | Labels | Avery File Folder Labels | 4.608 | 2 | 0.2 | 1.6704 |
| 7378 | CA-2014-132787 | 9/19/2014 | 9/23/2014 | Standard Class | MC-18130 | Mike Caudle | Corporate | United States | Seattle | Washington | 98115 | West | OFF-ST-10001321 | Office Supplies | Storage | Decoflex Hanging Personal Folder File, Blue | 92.520 | 6 | 0.0 | 24.9804 |
| 1732 | CA-2014-125136 | 9/28/2014 | 10/3/2014 | Standard Class | KD-16495 | Keith Dawkins | Corporate | United States | Fayetteville | North Carolina | 28314 | South | OFF-PA-10001804 | Office Supplies | Paper | Xerox 195 | 10.688 | 2 | 0.2 | 3.7408 |
| 1583 | CA-2015-131338 | 8/9/2015 | 8/12/2015 | First Class | NP-18325 | Naresj Patel | Consumer | United States | New York City | New York | 10024 | East | OFF-BI-10000545 | Office Supplies | Binders | GBC Ibimaster 500 Manual ProClick Binding System | 1217.568 | 2 | 0.2 | 456.5880 |
| 8761 | CA-2016-159891 | 1/31/2016 | 2/6/2016 | Standard Class | BF-11170 | Ben Ferrer | Home Office | United States | Atlanta | Georgia | 30318 | South | OFF-BI-10003527 | Office Supplies | Binders | Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind | 1270.990 | 1 | 0.0 | 635.4950 |
| 9176 | CA-2017-119424 | 6/12/2017 | 6/14/2017 | Second Class | SB-20185 | Sarah Brown | Consumer | United States | Kent | Washington | 98031 | West | OFF-PA-10001639 | Office Supplies | Paper | Xerox 203 | 19.440 | 3 | 0.0 | 9.3312 |
| 4674 | CA-2016-133550 | 7/31/2016 | 8/6/2016 | Standard Class | KL-16645 | Ken Lonsdale | Consumer | United States | Detroit | Michigan | 48205 | Central | TEC-PH-10001079 | Technology | Phones | Polycom SoundPoint Pro SE-225 Corded phone | 118.990 | 1 | 0.0 | 33.3172 |
| 6948 | CA-2015-130365 | 4/25/2015 | 4/29/2015 | Standard Class | ZC-21910 | Zuschuss Carroll | Consumer | United States | Aurora | Illinois | 60505 | Central | OFF-ST-10002574 | Office Supplies | Storage | SAFCO Commercial Wire Shelving, Black | 221.024 | 2 | 0.2 | -55.2560 |
| 8994 | CA-2017-159100 | 10/16/2017 | 10/21/2017 | Standard Class | VP-21760 | Victoria Pisteka | Corporate | United States | Columbia | Tennessee | 38401 | South | FUR-TA-10001950 | Furniture | Tables | Balt Solid Wood Round Tables | 1875.258 | 7 | 0.4 | -968.8833 |
| 199 | US-2017-124303 | 7/6/2017 | 7/13/2017 | Standard Class | FH-14365 | Fred Hopkins | Corporate | United States | Philadelphia | Pennsylvania | 19120 | East | OFF-BI-10000343 | Office Supplies | Binders | Pressboard Covers with Storage Hooks, 9 1/2” x 11”, Light Blue | 2.946 | 2 | 0.7 | -2.2586 |
| 2971 | CA-2017-167941 | 11/6/2017 | 11/9/2017 | Second Class | JF-15565 | Jill Fjeld | Consumer | United States | Fayetteville | North Carolina | 28314 | South | OFF-BI-10002827 | Office Supplies | Binders | Avery Durable Poly Binders | 13.272 | 8 | 0.7 | -10.6176 |
| 9076 | US-2015-136259 | 11/5/2015 | 11/8/2015 | First Class | CB-12415 | Christy Brittain | Consumer | United States | Lakewood | Ohio | 44107 | East | OFF-BI-10000773 | Office Supplies | Binders | Insertable Tab Post Binder Dividers | 7.218 | 3 | 0.7 | -5.5338 |
| 1938 | CA-2016-112109 | 7/8/2016 | 7/12/2016 | Standard Class | JE-15715 | Joe Elijah | Consumer | United States | Broomfield | Colorado | 80020 | West | OFF-BI-10002082 | Office Supplies | Binders | GBC Twin Loop Wire Binding Elements | 19.968 | 2 | 0.7 | -13.3120 |
| 1521 | CA-2017-109946 | 4/16/2017 | 4/21/2017 | Standard Class | PL-18925 | Paul Lucas | Home Office | United States | Chicago | Illinois | 60610 | Central | OFF-AR-10001419 | Office Supplies | Art | Newell 325 | 16.520 | 5 | 0.2 | 2.0650 |
| 1625 | CA-2015-157084 | 12/19/2015 | 12/24/2015 | Standard Class | JG-15160 | James Galang | Consumer | United States | Los Angeles | California | 90049 | West | TEC-PH-10002922 | Technology | Phones | ShoreTel ShorePhone IP 230 VoIP phone | 675.960 | 5 | 0.2 | 84.4950 |
| 4382 | CA-2015-152891 | 10/25/2015 | 10/30/2015 | Standard Class | TB-21625 | Trudy Brown | Consumer | United States | San Francisco | California | 94110 | West | FUR-TA-10001857 | Furniture | Tables | Balt Solid Wood Rectangular Table | 253.176 | 3 | 0.2 | -31.6470 |
| 4207 | CA-2014-145387 | 10/31/2014 | 11/2/2014 | Second Class | AM-10705 | Anne McFarland | Consumer | United States | Cranston | Rhode Island | 2920 | East | OFF-BI-10004001 | Office Supplies | Binders | GBC Recycled VeloBinder Covers | 34.080 | 2 | 0.0 | 15.6768 |
| 2704 | CA-2014-143413 | 5/24/2014 | 5/30/2014 | Standard Class | RP-19390 | Resi P |
Consumer | United States | Baltimore | Maryland | 21215 | East | OFF-PA-10002319 | Office Supplies | Paper | Xerox 1944 | 116.280 | 3 | 0.0 | 56.9772 |
| 7317 | CA-2016-132066 | 10/16/2016 | 10/20/2016 | Standard Class | NB-18655 | Nona Balk | Corporate | United States | New York City | New York | 10011 | East | FUR-TA-10001539 | Furniture | Tables | Chromcraft Rectangular Conference Tables | 142.182 | 1 | 0.4 | -37.9152 |
| 9568 | CA-2014-130428 | 3/31/2014 | 3/31/2014 | Same Day | TG-21640 | Trudy Glocke | Consumer | United States | Tampa | Florida | 33614 | South | OFF-AR-10004027 | Office Supplies | Art | Binney & Smith inkTank Erasable Desk Highlighter, Chisel Tip, Yellow, 12/Box | 4.032 | 2 | 0.2 | 1.0584 |
| 831 | CA-2017-129462 | 6/16/2017 | 6/21/2017 | Second Class | JE-15745 | Joel Eaton | Consumer | United States | Florence | Kentucky | 41042 | South | OFF-AP-10003884 | Office Supplies | Appliances | Fellowes Smart Surge Ten-Outlet Protector, Platinum | 180.660 | 3 | 0.0 | 50.5848 |
| 2926 | CA-2014-157721 | 9/2/2014 | 9/5/2014 | First Class | JM-16195 | Justin MacKendrick | Consumer | United States | Watertown | New York | 13601 | East | FUR-FU-10002116 | Furniture | Furnishings | Tenex Carpeted, Granite-Look or Clear Contemporary Contour Shape Chair Mats | 70.710 | 1 | 0.0 | 4.9497 |
| 5051 | CA-2015-150511 | 9/18/2015 | 9/24/2015 | Standard Class | AB-10060 | Adam Bellavance | Home Office | United States | Des Moines | Washington | 98198 | West | OFF-PA-10001776 | Office Supplies | Paper | Wirebound Message Books, Four 2 3/4” x 5” Forms per Page, 600 Sets per Book | 18.540 | 2 | 0.0 | 8.7138 |
| 1848 | CA-2017-128370 | 9/10/2017 | 9/10/2017 | Same Day | FH-14275 | Frank Hawley | Corporate | United States | Los Angeles | California | 90004 | West | FUR-CH-10002602 | Furniture | Chairs | DMI Arturo Collection Mission-style Design Wood Chair | 362.352 | 3 | 0.2 | 27.1764 |
| 246 | CA-2014-131926 | 6/1/2014 | 6/6/2014 | Second Class | DW-13480 | Dianna Wilson | Home Office | United States | Lakeville | Minnesota | 55044 | Central | OFF-ST-10002276 | Office Supplies | Storage | Safco Steel Mobile File Cart | 166.720 | 2 | 0.0 | 41.6800 |
| 5093 | CA-2015-119102 | 5/23/2015 | 5/27/2015 | Standard Class | KH-16690 | Kristen Hastings | Corporate | United States | Woonsocket | Rhode Island | 2895 | East | OFF-ST-10004507 | Office Supplies | Storage | Advantus Rolling Storage Box | 51.450 | 3 | 0.0 | 13.8915 |
$ 25,200
$ -8,880
$ 134,119
$ 91,979
$ 60,299